2017-08-28 - 44153- Rel Notes - SAP program to capture sales related postings add Fright GL, order iD and summerization #SAPReleases2017

Release Notes - Draft / Final


44153: SAP prgram to capture sales related postings


Admin Info



Purpose
SAP prgram to capture sales related postings add fright GL, order ID, summerization and posting date logic
Release No
003
Submitted on
08/28/2017
Submitted by
Raghav
Environment
NECNEQ to NEP
Sent To
Baiwa
Object(s) created by
Damodhier
Object(s) tested by
Raghav
Transport Status
Created in NECNED300 / 100

Transport and Technical Objects


Sl.
Transport ID
Description
Object Name
1
NEDK941727
FICO:44153:ECOMM Sales wt FrieghtGL,order ID &Summarization
ZFI_RTL_ECM_SALES





Release Notes


For Infrastructure

NA

For Requestor

Below is the previous transport.
1. NEDK940963 - FICO:44153:Retail/ECOM custom table with store ID and GL A/C
2. NEDK941072 - FICO:44153:Retail/ECOM sales related postings
3. NEDK941296 - FICO:44153:Post.Date addition. in sel, Subsidiary length chg
4. NEDK941326 - FICO:44153:Retail/ECOM sales error LOG & email notification
5. NEDK941418 - FICO:44153:Retail/ECOM Sales/paymt TVARVC to maintain Email
6. NEDK941685 - FICO:44153:Sales ECOMM inventory GL change to 211310




Test Notes


System : NECNED300

Test ID
Test Scenario
Expected Results
Actual Results
P/F
Documents
Notes
Tested By
QA By
FI-001
Sales related posting with single file cocd 0011to run program ZFI_RTL_ECM_SALES in foreground
Sales file should post to customer given in input file with respective GL accounts Net sales (excluding tax),VAT,Total AR,Inventory change, Revenue/Gift card, COGS,Royalty,Know-how and Brand
Customer invoice and credit memo posted sucessfully to respective GL accounts
P
File: 0021_20170825_1009_ECOM_Sales
Document : 1800000155
Document : 1800000156
Document : 1600000010
N/A
Raghav
Raghav
FI-002
Sales related posting with multiple files with multiple company codes to run with tcode ZFI_Sales in background with posting date
1) All Sales file should first summerize the fields Inventory change,COGS,Royalty,Know-how,Brand,Category,UUID,Order ID based on Order ID and summerize based on customer category and UUID
2) Archive files once processed, also the error records should move to LOG folder with adding name LOG at end of the file name. 3) Email has to be send if the any file have errors
4)All the processed document should pick the posting date from input field and document date from file
All sales files summerized as per thr requirement and process at once with the given input posting date also archive the file and error records in file moved to LOG folder with filename ending LOG
Email has been sent
P
File: 0011_20170825_1006_ECOM_Sales
0011_20170825_1007_ECOM_Sales
0021_20170825_1008_ECOM_Sales
Company code 0011
Document : 1800000283
Document : 1800000284
Document : 1800000285
Document : 1800000286
Document : 1800000287
Document : 1800000288
Document : 1800000289
Document : 1600000140
Company code 0021
Document : 1800000152
Document : 1800000153
Document : 1800000154
N/A
Raghav
Raghav

0011_20170825_1006_ECOM_Sales.txt0011_20170825_1007_ECOM_Sales.txt0021_20170825_1008_ECOM_Sales.txt0021_20170825_1009_ECOM_Sales.txt


Reference Document (Specification or Production Support Break Fix)


  1. FICO - Raghav - Damodhier - 2017-06-28 - 44153 - Spec - ABAP - SAP program to capture sales related postings (Baiwa by 2017-07-15)